"192.168.0.1:sipop" Previous topic Chapter index Next topic

DETALLESFICHATECNICA

 

 

Descriptions

DETALLE DE UNA FICHA TECNICA

 

Fields

PK

FK

Name

Domain

Data type

Not null

Default

Description

 

 

NOMBRE_CAMPO

 

VARCHAR (30)

 

 

 

 

ITEM_NUMERO

 

VARCHAR (8)

 

 

 

COD_FICHATECNICA

 

VARCHAR (30)

 

 

 

Triggers

There are no triggers for table DETALLESFICHATECNICA

 

Indices

There are no indices for table DETALLESFICHATECNICA

 

References

Table

Foreign Key

Fields

FK Fields

DEL Rule

UPD Rule

FICHATECNICA

INTEG_255

COD_FICHATECNICA

ID_FICHATECNICA

RESTRICT

RESTRICT

 

Referenced

There are no tables referenced by table DETALLESFICHATECNICA

 

Definition


CREATE TABLE DETALLESFICHATECNICA (
    NOMBRE_CAMPO VARCHAR (30) CHARACTER SET NONE NOT NULL COLLATE NONE,
    ITEM_NUMERO VARCHAR (8) CHARACTER SET NONE NOT NULL COLLATE NONE,
    COD_FICHATECNICA VARCHAR (30) CHARACTER SET NONE NOT NULL COLLATE NONE);

ALTER TABLE DETALLESFICHATECNICA ADD  FOREIGN KEY (COD_FICHATECNICA) REFERENCES FICHATECNICA (ID_FICHATECNICA);

    This file was generated with EMS InterBase/FireBird Manager (www.ibmanager.com) at 09/06/2005 05:52 p.m. Previous topic Chapter index Next topic